Number tab

Use the Number tab (click Customize on the Number tab of the Format Editor) to set detailed formatting options for number fields in your report.

Use Accounting Format

When you select this option:

Suppress if Zero

When you select this check box, nothing is printed in a column of number field data if it the value is zero.

Decimals

When you are setting up a custom format for a number field object, use this list to set the Decimals property for that object. This option allows you to specify the number of decimal places you want to print. You can specify from 0 to 10 decimal places. When you choose the number of decimal places you want, the program changes the sample number at the bottom of the dialog box to show you the results of your selection.

Rounding

When you are setting up a custom format for a number field object, use this list to set the Rounding property for that object. This property allows you to specify the number of places you want to round to. When you choose the number of places you want, the program changes the sample number at the bottom of the dialog box to show you the results of your selection.

Negatives

When you are setting up a custom format for a number field object, this property enables you to specify the way you want negative values to appear. Your options are:

-1.23

Prints negative values with a leading minus sign (-100.00, -225.73, -1,000,000).

1.23-

Prints negative values with a trailing minus sign (100.00-, 225.73-, 1,000,000.00-).

(1.23)

Prints negative values in parentheses [ (100.00), (225.73), (1,000,000) ].

Set the Negatives property to fit your needs. The program changes the sample number at the bottom of the dialog box to reflect the property you choose.

Reverse Sign for Displaying

You can reverse the sign for debit and credit amounts in financial reports by selecting this check box.

Allow Field Clipping

The Allow Field Clipping check box determines whether overflow field representation is enabled for the selected field(s).

Decimal separator

When you are setting up a custom format for a number field object, the Decimal box allows you to type in the character(s) you want to use as a decimal separator. The default is a decimal point (.). If you want to change the separator, replace the character in the edit box with the separator of your choice. The program modifies the sample number at the bottom of the dialog box as you type in your characters.

Note:    The box does not expand as you type in your separation characters; you are limited to the number of characters the box will hold.

Thousands Separator

The Thousands separator property allows you to choose the way you want numbers over 999 to appear on your reports.

Symbol

This box displays the current thousands separator. The default is a comma (,). If you would like to use a different thousands separator, type it in this box. The changes you make in this box do not apply unless you select the Thousands Separator check box.

Leading Zero

Leading Zero allows you to include a zero, if you wish, before the decimal point in decimal amounts less than one.

Show Zero Values as

This list contains the options available for displaying values of zero (0) in the selected field.

Related topics

Format Editor

Formatting



Seagate Software IMG Holdings, Inc.
http://www.seagatesoftware.com
Support services:
http://support.seagatesoftware.com